package com.trkj.dao.wdm;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Ygzttable;

public interface YgztTableDAO extends CrudRepository<Ygzttable, Long>{
	@Query("select y,j,s from Ygzttable y inner join y.jobStatus j inner join y.staffInformation s ")
	public List<Object[]> queryByNaPage(Pageable p);
}
